<?php

class m120506_032300_update_chapter extends CDbMigration {

	// Use safeUp/safeDown to do migration with transaction
	public function safeUp() {
		$this->addColumn('chapters', 'volume', 'integer');
		$this->addColumn('chapters', 'sequence', 'integer');
		$this->addColumn('chapters', 'subSequence', 'varchar(1)');
	}

	public function safeDown() {
		$this->dropColumn('chapters', 'subSequence');
		$this->dropColumn('chapters', 'sequence');
		$this->dropColumn('chapters', 'volume');
	}

}